Workday to Work.com (Salesforce) Employee Data - Implementation Template
Mappings: Employee object
| Workday | Field name | Data Type | Description |
|---|---|---|---|
| Worker/Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/ Name_Detail_Data/First_Name | First Name | TEXT(40) | The employee's first name |
| Worker/Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/ Name_Detail_Data/Last_Name | Last Name | TEXT(80) | The employee's last name |
| Worker/Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/ Name_Detail_Data/Middle_Name | Middle Name | TEXT(40) | The employee's middle name |
| Worker/Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/ Name_Detail_Data/Last_Name | Name Suffix | TEXT(40) | The employee's suffix |
| Worker/Worker_Data/Personal_Data/Name_Data/Preferred_Name_Data/ Name_Detail_Data/First_Name | Preferred First Name | TEXT(40) | The name the employee prefers to be called |
| Worker/Worker_Data/Personal_Data/Birth_Date | Date of Birth | DATE | The employee's date of birth |
| Worker/Worker_Data/Gender_Reference/ID(@type=Gender_Code) | Gender | PICKLIST | The employee's gender |
| Worker/Worker_Reference/ID(@type=Employee_ID) | Employee Number | "TEXT(40) Unique-CaseInsensitiveExternal ID" | The employee's employment ID for the organization they were hired into |
| Worker/Worker_Reference/ID(@type=Employee_ID) | Worker Type | PICKLIST | The type of worker (Employee, Contractor, Intern) |
| Worker/Worker_Data/Personal_Data/Contact_Data/Email_Address_Data/ Email_Address ( ID= WORK) | The employee's email address | ||
| Worker/Worker_Data/Personal_Data/Contact_Data/Phone_Data (@Workday_Traditional_Formatted_Phone) (Usage_Data/Type_Data/Type_Reference/ID = HOME) | Home Phone | PHONE | The employee's home phone number |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Address_Line_Data (Communication_Usage_Type_ID=HOME) | Home Street | TEXT(255) | The street detail for the address. For example, this field is known as MailingStreet on Contact. |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Municipality (Communication_Usage_Type_ID=HOME) | Home City | TEXT(40) | The city detail for the address. For example, this field is known as MailingCity on Contact. |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Country_Reference/ID (@type=ISO_3166-1_Alpha-2_Code) | Home State | TEXT(80) | The state detail for the address. For example, this field is known as MailingState on Contact. |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Postal_Code (Communication_Usage_Type_ID=HOME) | Home Postal Code | TEXT(20) | The postal code for the address. For example, this field is known as MailingPostalCode on Contact. |
| Worker/Worker_Data/Personal_Data/Contact_Data/Address_Data/ Country_Region_Reference/ID (@type=ISO_3166-2_Code) | Home Country | TEXT(80) | The country detail for the address. For example, this field is known as MailingCountry on Contact. |
| Worker/Worker_Data/Employment_Data/Worker_Status_Data/Active; Note: There is a transformation required here. If Active=0 and Terminated=0 then 'InActive'; If Active=0 and Terminated=1 then 'Terminated'; If Active=1 and Leave_Status_Data/On_Leave=1 then 'Leave', else 'Active' | Employee Status | PICKLIST | The employee's current work status |
| Worker/Worker_Data/Employment_Data/Position_Data/Start_Date | Status As Of | DATE | Start date of the employee's current status |
| Worker/Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/ End_Employment_Date | Status End Date | DATE | The planned end date for the employee's status |
| Worker/Worker_Data/Employment_Data/Position_Data/ Position_Time_Type_Reference/ID (@type=Position_Time_Type_ID) | Employment Type | PICKLIST | The employee's full-time or part-time status |
| Worker/Worker_Data/Personal_Data/Contact_Data/ Email_Address_Data/Email_Address ( ID= HOME) | Alternate Email | The employee's alternate email address | |
| Worker/Worker_Data/Personal_Data/Contact_Data/ Phone_Data (@Workday_Traditional_Formatted_Phone) (Usage_Data/Type_Data/Type_Reference/ID = WORK) | Work Phone | PHONE | The employee's formatted work phone number including country code and extension |
| /Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/ Manager_as_of_last_detected_manager_change_Reference/ ID(@type=Employee_ID) Note: Externalize the parameter Employee_ID as it may differ from customer to customer | Manager | LOOKUP(EMPLOYEE__C) | A reference to the Employee record of the employee's manager |
| /Worker_Data/Employment_Data/Worker_Job_Data/ Position_Data/Position_Title | Job Profile | PICKLIST | The employee's job profile at the company |
| /Work_Space_Reference/ID (@type='Location_ID') Note: Externalize the parameter Location_ID as it may differ from customer to customer | Location | LOOKUP(LOCATION) | A reference to the Location that this employee is assigned to |
| /Worker/Worker_Data/Organization_Data/Worker_Organization_Data/ Organization_Data/ Organization_Code (where ../Organization_Type_Reference/ID (@type='Organization_Type_ID')='COST_CENTER' (depends on customer choice, based on a property) | InternalOrganizationUnit | LOOKUP(InternalOrganizationUnit) | A reference to the organization that this employee is assigned to |